Stored Procedures [dbo].[BAEImisNameSecuritySave]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Idvarchar(10)10
@loginDisabledbit1
@expirationDatedatetime8
@lastlogindatetime8
@previousLogindatetime8
@webLoginvarchar(60)60
@passwordvarchar(100)100
SQL Script
create procedure [dbo].[BAEImisNameSecuritySave] @Id varchar(10),
     @loginDisabled bit,
     @expirationDate datetime,
     @lastlogin datetime,
     @previousLogin datetime,
     @webLogin varchar(60),
     @password varchar(100) as
UPDATE Name_Security
    SET LOGIN_DISABLED = @loginDisabled,
        EXPIRATION_DATE = @expirationDate,
        LAST_LOGIN = @lastlogin,
        PREVIOUS_LOGIN = @previousLogin,
        WEB_LOGIN = @webLogin,
        [PASSWORD] = @password
    WHERE ID = @Id

GO
Uses